'use strict';

module.exports = {
  up: async (queryInterface, Sequelize) => {
    await queryInterface.bulkInsert('clothing', [
      // 上装
      {
        id: 1,
        user_id: 1,
        category_id: 11, // T恤
        name: '白色基础T恤',
        brand: 'UNIQLO',
        size: 'M',
        color: '白色',
        color_hex: '#FFFFFF',
        material: '100%棉',
        price: 59.00,
        purchase_date: new Date('2024-01-15'),
        purchase_place: '优衣库官网',
        season: 'all',
        style: 'casual',
        occasion: JSON.stringify(['daily', 'casual']),
        status: 'available',
        wear_count: 5,
        care_instructions: '机洗，低温烘干',
        notes: '百搭基础款，很舒适',
        is_favorite: true,
        created_at: new Date(),
        updated_at: new Date(),
      },
      {
        id: 2,
        user_id: 1,
        category_id: 12, // 衬衫
        name: '蓝色条纹衬衫',
        brand: 'ZARA',
        size: 'S',
        color: '蓝色',
        color_hex: '#4169E1',
        material: '棉混纺',
        price: 199.00,
        purchase_date: new Date('2024-02-10'),
        purchase_place: 'ZARA门店',
        season: 'all',
        style: 'business',
        occasion: JSON.stringify(['work', 'formal']),
        status: 'available',
        wear_count: 8,
        care_instructions: '干洗或手洗',
        notes: '适合商务场合',
        is_favorite: false,
        created_at: new Date(),
        updated_at: new Date(),
      },
      {
        id: 3,
        user_id: 1,
        category_id: 13, // 毛衣
        name: '灰色羊毛毛衣',
        brand: 'H&M',
        size: 'M',
        color: '灰色',
        color_hex: '#808080',
        material: '羊毛',
        price: 299.00,
        purchase_date: new Date('2023-11-20'),
        purchase_place: 'H&M官网',
        season: 'winter',
        style: 'casual',
        occasion: JSON.stringify(['daily', 'date']),
        status: 'available',
        wear_count: 12,
        care_instructions: '手洗，平铺晾干',
        notes: '保暖又时尚',
        is_favorite: true,
        created_at: new Date(),
        updated_at: new Date(),
      },
      
      // 下装
      {
        id: 4,
        user_id: 1,
        category_id: 21, // 牛仔裤
        name: '深蓝色直筒牛仔裤',
        brand: "Levi's",
        size: '27',
        color: '深蓝色',
        color_hex: '#191970',
        material: '棉+弹性纤维',
        price: 599.00,
        purchase_date: new Date('2024-01-05'),
        purchase_place: "Levi's专卖店",
        season: 'all',
        style: 'casual',
        occasion: JSON.stringify(['daily', 'casual']),
        status: 'available',
        wear_count: 15,
        care_instructions: '机洗，自然晾干',
        notes: '经典款式，很显瘦',
        is_favorite: true,
        created_at: new Date(),
        updated_at: new Date(),
      },
      {
        id: 5,
        user_id: 1,
        category_id: 22, // 休闲裤
        name: '黑色阔腿裤',
        brand: 'MANGO',
        size: 'S',
        color: '黑色',
        color_hex: '#000000',
        material: '聚酯纤维',
        price: 259.00,
        purchase_date: new Date('2024-03-01'),
        purchase_place: 'MANGO门店',
        season: 'all',
        style: 'formal',
        occasion: JSON.stringify(['work', 'party']),
        status: 'available',
        wear_count: 6,
        care_instructions: '干洗',
        notes: '很有气质的裤子',
        is_favorite: false,
        created_at: new Date(),
        updated_at: new Date(),
      },
      
      // 外套
      {
        id: 6,
        user_id: 1,
        category_id: 31, // 夹克
        name: '米色风衣',
        brand: 'ONLY',
        size: 'M',
        color: '米色',
        color_hex: '#F5F5DC',
        material: '聚酯纤维',
        price: 399.00,
        purchase_date: new Date('2023-10-15'),
        purchase_place: 'ONLY官网',
        season: 'autumn',
        style: 'casual',
        occasion: JSON.stringify(['daily', 'date']),
        status: 'available',
        wear_count: 10,
        care_instructions: '干洗',
        notes: '春秋必备外套',
        is_favorite: true,
        created_at: new Date(),
        updated_at: new Date(),
      },
      
      // 鞋子
      {
        id: 7,
        user_id: 1,
        category_id: 41, // 运动鞋
        name: '白色小白鞋',
        brand: 'Nike',
        size: '37',
        color: '白色',
        color_hex: '#FFFFFF',
        material: '皮革+橡胶',
        price: 599.00,
        purchase_date: new Date('2024-02-20'),
        purchase_place: 'Nike官网',
        season: 'all',
        style: 'casual',
        occasion: JSON.stringify(['daily', 'sport']),
        status: 'available',
        wear_count: 20,
        care_instructions: '用湿布擦拭',
        notes: '百搭神器',
        is_favorite: true,
        created_at: new Date(),
        updated_at: new Date(),
      },
      {
        id: 8,
        user_id: 1,
        category_id: 42, // 皮鞋
        name: '黑色高跟鞋',
        brand: 'Charles & Keith',
        size: '37',
        color: '黑色',
        color_hex: '#000000',
        material: '人造皮革',
        price: 299.00,
        purchase_date: new Date('2024-01-25'),
        purchase_place: 'Charles & Keith门店',
        season: 'all',
        style: 'formal',
        occasion: JSON.stringify(['work', 'party', 'formal']),
        status: 'available',
        wear_count: 8,
        care_instructions: '用皮革保养剂护理',
        notes: '正式场合必备',
        is_favorite: false,
        created_at: new Date(),
        updated_at: new Date(),
      },
      
      // 配饰
      {
        id: 9,
        user_id: 1,
        category_id: 52, // 包包
        name: '棕色单肩包',
        brand: 'Coach',
        size: 'M',
        color: '棕色',
        color_hex: '#8B4513',
        material: '真皮',
        price: 1299.00,
        purchase_date: new Date('2023-12-10'),
        purchase_place: 'Coach专柜',
        season: 'all',
        style: 'business',
        occasion: JSON.stringify(['work', 'daily']),
        status: 'available',
        wear_count: 25,
        care_instructions: '定期用皮革保养剂护理',
        notes: '质量很好，很实用',
        is_favorite: true,
        created_at: new Date(),
        updated_at: new Date(),
      },
      {
        id: 10,
        user_id: 1,
        category_id: 51, // 帽子
        name: '黑色贝雷帽',
        brand: '无品牌',
        size: 'F',
        color: '黑色',
        color_hex: '#000000',
        material: '羊毛',
        price: 89.00,
        purchase_date: new Date('2024-03-15'),
        purchase_place: '淘宝',
        season: 'autumn',
        style: 'vintage',
        occasion: JSON.stringify(['daily', 'date']),
        status: 'available',
        wear_count: 3,
        care_instructions: '手洗',
        notes: '很有文艺气息',
        is_favorite: false,
        created_at: new Date(),
        updated_at: new Date(),
      },
    ]);
  },

  down: async (queryInterface, Sequelize) => {
    await queryInterface.bulkDelete('clothing', { user_id: 1 }, {});
  },
};
